enq: IV - contention
Enqueue wait. Invalidation of library cache object across RAC instances.
Additional Information​
An enqueue is a wait for a resource held by another.
Invalidation of library cache object across RAC instances. Library Cache objects include SQL and PL/SQL package, procedure and function source statements, parsing and cursor information for statements and execution plans for statements.
How to reduce this wait​
There are references to a bug 21418655 at versions below 18.1 in this article by Jonathan Lewis and further reading on My Oracle Sypport (MOS).
Doc ID 2028503.1 12c RAC DDL Performance Issue: High “enq: IV – contention” etc if CPU Count is Different
Doc ID 2301046.1 “Enq: IV – Contention”, summary invalidations, and summary management compile
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.